home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Belgian Amiga Club - ADF Collection
/
BS1 part 60.zip
/
BS1 part 60
/
Prof. Calc d3.adf
/
Examples
/
User_Formulas.pcf
(
.txt
)
< prev
Wrap
Gold Disk Spreadsheet
|
1991-12-11
|
3KB
|
48 lines
:FIVER
COMMISSN
User Defined Formulas
3Example 1: This cell contains a simple formula ==>
MThis formula multiplies the cell to the right by 5. It has been named FIVER.
topaz.font
#The formula is used in this table:
Five Times
Value
FIVER
topaz.font
FIVER
topaz.font
FIVER
topaz.font
>Example 2: Here's another, more complex, formula -----------v
0.035
NThis formula (COMMISSN) calculates the commissions due, based on total sales.
137.5
topaz.font
Bonus
Salesperson
Sales
Total Sales
Commission
Johnson, J.
10000.00
1200.00
0.035
15000.00
COMMISSN
topaz.font
Smythe, S.
8000.00
700.00
0.025
7500.00
700.00
COMMISSN
topaz.font
Van Gogh, V.
12000.00
1100.00
0.039
14000.00
COMMISSN
topaz.font